from sqlite3 import *

conn = connect('temp.db3')
curs = conn.cursor()
sql0 = '''CREATE TABLE [login] (
  [id] BIGINT(100) NOT NULL ON CONFLICT ROLLBACK, 
  [name] VARCHAR(100) NOT NULL ON CONFLICT ROLLBACK, 
  [password] VARCHAR(100) NOT NULL ON CONFLICT ROLLBACK, 
  [status] VARCHAR(2) NOT NULL ON CONFLICT ROLLBACK)'''

curs.execute(sql0)
sql = '''INSERT INTO login VALUES(1,'kevin','blackid','1') '''
curs.execute(sql)
sql2 = '''SELECT * FROM login'''
curs.execute(sql2)
conn.commit()

for row in curs:
    print row